
Accounts table
id
account_code
account_name
account_type
bank_name
account_number
created_at
updated_at


Bank Transactions table
id
transaction_date
reference
amount
type
description
supporting_document
account_id
deposit_slip
cheque_number
mobile_transaction_id
bank_name
reconciled
created_at
updated_at
linked_sales_batch_id
linked_expense_id
linked_payment_id
reconciliation_status
linked_financial_transaction_id
status
created_by


Financial transactions table
id
transaction_date
account_id
type
amount
payment_method
account
description
reference_id
store_id
created_by
status
created_at
updated_at
reconciliation_status
linked_bank_transaction_id
debit
credit
linked_sale_id
linked_bank_txn_id


Payments table
id
sale_id
payment_method
amount
created_at
created_by


Sales items table
id
transaction_id
product_id
quantity
unit_price
discount
vat_rate
total_price
created_at


Sales transactions table
id
store_id
sold_by
customer_name
receipt_number
total_amount
discount_total
vat_total
payment_method
created_at
transaction_type
status
customer_id
amount_paid